Hi,
The below are the values stored in DB.
2013.ack
2013.regres
2013.zip.ack
Here I need to trim the values before the last dot(.).
The output should be like below
2013.
2013.
2013.zip.
Home / DeveloperSection / Forums / How To Split From Last Dot In Sql Server?
Anonymous User
27-Oct-2014Please try with below sample